package org.duanyu.shopping_category_service.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.dubbo.config.annotation.DubboService;
import org.duanyu.shopping_category_service.mapper.CategoryMapper;
import org.duanyu.shopping_common.pojo.Category;
import org.duanyu.shopping_common.service.CategoryService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.ListOperations;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.Arrays;
import java.util.List;

@DubboService
@Transactional
public class CategoryServiceImpl implements CategoryService {

    @Autowired
    private CategoryMapper categoryMapper;

    @Autowired
    private RedisTemplate redisTemplate;

    @Override
    public void add(Category category) {
        categoryMapper.insert(category);
        refreshRedisCategory();
    }

    @Override
    public void update(Category category) {
        categoryMapper.updateById(category);
        refreshRedisCategory();
    }

    @Override
    public void updateStatus(Long id, Integer status) {
        Category category = categoryMapper.selectById(id);
        category.setStatus(status);
        categoryMapper.update(category, null);
        refreshRedisCategory();
    }

    @Override
    public void delete(Long[] ids) {
        categoryMapper.deleteBatchIds(Arrays.asList(ids));
    }

    @Override
    public Category findById(Long id) {
        return categoryMapper.selectById(id);
    }

    @Override
    public Page<Category> search(int page, int size) {
        return categoryMapper.selectPage(new Page<>(page, size), null);
    }

    @Override
    public List<Category> findAll() {

        //从redis中查询所有启用广告
        //1.1获取操作redis中list数据的对象
        ListOperations<String, Category> listOperations = redisTemplate.opsForList();
        //1.2从Redis中获取所有启用对象
        List<Category> categoryList = listOperations.range("categories", 0, -1);
        if (categoryList != null && !categoryList.isEmpty()) {
            //2.如果查询到结果，直接返回
            System.out.println("从redis中查询广告");
            return categoryList;
        } else {
            //如果没有查到，则从数据库中查询所有启用广告,缓存到redis中
            QueryWrapper<Category> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("status", 1);
            List<Category> categories = categoryMapper.selectList(queryWrapper);
            //同步到redis中
            listOperations.leftPushAll("categories", categories);
            return categories;
        }
    }

    public void refreshRedisCategory(){
        //从数据库查询广告
        QueryWrapper<Category> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("status", 1);
        List<Category> categories = categoryMapper.selectList(queryWrapper);
        //删除redis中原有的广告数据
        redisTemplate.delete("category");
        //将新的广告数据同步到redis中
        ListOperations<String,Category> listOperations = redisTemplate.opsForList();
        listOperations.leftPushAll("categories",categories);
    }

}
